Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
OBJ VARCHAR2(20) No null 1 null NO NO NO
SH_OBJ VARCHAR2(20) No null 2 null NO NO NO
SH_DISPLAY VARCHAR2(400) Yes null 3 null NO NO NO
START_DATE DATE No null 4 null NO NO NO
END_DATE DATE Yes null 5 null NO NO NO
SH_ROLE NUMBER(38) No null 6 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_ALL_FILES_INTAKE_ASSOC VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW
QART V_ALL_INACTIVE_ACTIVITIES VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW
QART V_BEHAVE_SCI_FILES VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW
QART V_F_ANP VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW
QART V_SIII_INV_ACTS VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW
QART MV_SIIA_ANALYSIS MATERIALIZED VIEW QART V_CURR_OBJ_SUPPORT_OFFICER VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER TABLE
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_OBJ TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER_ROLE TABLE
QART V_CURR_OBJ_SUPPORT_OFFICER VIEW QART MV_ACM_STAKEHOLDER TABLE
NAME VALUE
CREATED 12-APR-23
LAST_DDL_TIME 12-APR-23
OWNER QART
VIEW_NAME V_CURR_OBJ_SUPPORT_OFFICER
TEXT_LENGTH 553
TEXT SELECT S.OBJ,           S.STAKEHOLDER SH_OBJ,           SH.TAGLINE SH_DISPLAY,           S.START_DATE,           S.END_DATE,           S.SH_ROLE      FROM MV_ACM_STAKEHOLDER S     INNER JOIN MV_ACM_OBJ SH ON SH.SID = S.STAKEHOLDER     WHERE ( S.START_DATE IS NULL        OR S.START_DATE <= SYSTIMESTAMP )       AND ( S.END_DATE IS NULL        OR S.END_DATE >= SYSTIMESTAMP )       AND S.SH_ROLE IN ( SELECT SID                                            FROM MV_ACM_STAKEHOLDER_ROLE                        WHERE CODE = 'SUPPORT'                        )
TEXT_VC SELECT S.OBJ,           S.STAKEHOLDER SH_OBJ,           SH.TAGLINE SH_DISPLAY,           S.START_DATE,           S.END_DATE,           S.SH_ROLE      FROM MV_ACM_STAKEHOLDER S     INNER JOIN MV_ACM_OBJ SH ON SH.SID = S.STAKEHOLDER     WHERE ( S.START_DATE IS NULL        OR S.START_DATE <= SYSTIMESTAMP )       AND ( S.END_DATE IS NULL        OR S.END_DATE >= SYSTIMESTAMP )       AND S.SH_ROLE IN ( SELECT SID                                            FROM MV_ACM_STAKEHOLDER_ROLE                        WHERE CODE = 'SUPPORT'                        )
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT